package com.smbms.dao;

import com.smbms.pojo.Provider;
import org.apache.ibatis.annotations.Insert;

import java.util.List;

public interface ProviderMapper {
    List<Provider> getsmbmsprovider();

  @Insert("insert into smbms_provider values (null, #{proCode}, #{proName}, #{proDesc}, #{proContact},  #{proPhone}, #{proAddress},#{proFax},#{createdBy},#{creationDate}, null,null)")
    Integer addProvider(Provider provider);

    Integer delProvider(String proCode);

    Integer upProvider(Provider provider);
    //根据供应商ID查出供应商和订单表的信息
    Provider getProviderandBillById(Integer i);

}
